
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[WordTemplateInsert]
	@Id INT OUTPUT,
	@Template VARBINARY(MAX),
	@FileName VARBINARY(MAX),
	@Description VARBINARY(MAX),
	@Visible BIT
AS
BEGIN
	
	INSERT INTO WordTemplate
		(Template, FileName, Description, DateCreated, Visible, Deleted)
	VALUES 
		(@Template, @FileName, @Description, GETDATE(), @Visible, 0);
	
	SET @Id = SCOPE_IDENTITY();
	
END


GO
